Connection

A valid connection string for the database with which to execute the query.

This parameter also accepts a variable that represents one of the following vault databases. The variables are case-sensitive.

$$TransManDB – The Transmittal Management Module database (if installed)

$$UserDB – The user account database

Note    When the Use Enterprise Server for user management option is enabled in the EDM Server properties in Meridian Enterprise Administrator, the reserved word $$UserDB cannot be used in VBScript with the Vault.ExecSQL method to access the Meridian Enterprise Server user database.

$$<QueryName> – An external table query connection string created as described in the BlueCielo Meridian Enterprise Configuration Guide.

Query

A valid SQL query expression.

Parameters

Optional value or array of values to be used in a parametric query. The values do not need to be strings. The array should contain a value for each instance of the ? character in the SQL query.